/**
 * Created with IntelliJ IDEA.
 * Description:
 * User: WHY
 * Date: 2022-08-22
 * Time: 22:42
 */
public class TestDemo {

    public static void main(String[] args) {
        create table emp(name varchar(20),sex varchar(10),depart varchar(20),salary int);
        insert into emp values('李四','男','测开',23000);
        insert into emp values('刘洋','男','研发',26000);
        insert into emp values('王五','男','产品',11000);
        insert into emp values('周倩','女','研发',26000);
        insert into emp values('李四','男','人力资源',20000);
        insert into emp values('刘洋','女','策划',12000);
        insert into book  values('Java核心技术','Cay S.Horstman',56.43,'计算机技术');
        create table book(name varchar(20),author varchar(20),price int ,sort varchar(20));
        insert into book  values('学生书包','null','18.91','101');
        create table student(name varchar(20),age int ,score int );
        insert into student values('李华','18','120'),('王一博','25',150),('小魏','19',130),('金花','66','88');
    }
}
